package org.mcflier.appuntamento.io.driver.db.interfaces;


public interface IJDBCDriver extends IJDBCMovieDriver, IJDBCGenreDriver, IJDBCProductionDriver, IJDBCCountryDriver, IJDBCLanguageDriver, IJDBCTorrentDriver {

	public static final String USER_KEY = "user";
	public static final String PASSWORD_KEY = "password";
	public static final String JDBC_URL_KEY ="jdbc_url";
	public static final String JDBC_DRIVER = "jdbc_driver";
	
	public static final String MOVIE_TABLE = "movie";
	public static final String MOVIE_IDMOVIE = "idMovie";
	public static final String MOVIE_ORIGINAL_TITLE = "originalTitle";
	public static final String MOVIE_POSTER_PATH = "posterPath";
	public static final String MOVIE_HOMEPAGE = "homepage";
	public static final String MOVIE_RUNTIME = "runtime";
	public static final String MOVIE_RELEASE_DATE = "releaseDate";
	public static final String MOVIE_TRACED = "traced";
	
	public static final String GENRE_TABLE = "genre";
	public static final String GENRE_ID = "idgenre";
	public static final String GENRE_NAME = "name";
	
	public static final String COUNTRY_TABLE = "country";
	public static final String COUNTRY_CODE = "code";
	public static final String COUNTRY_NAME = "name";
	
	public static final String LANGUAGE_TABLE = "language";
	public static final String LANGUAGE_CODE = "code";
	public static final String LANGUAGE_NAME = "name";
	
	public static final String PRODUCTION_TABLE = "production";
	public static final String PRODUCTION_IDPRODUCTION = "idproduction";
	public static final String PRODUCTION_NAME = "name";
	
	public static final String MOVIE_GENRE_TABLE = "movie_genre";
	public static final String MOVIE_GENRE_IDMOVIE = "movie_idMovie";
	public static final String MOVIE_GENRE_IDGENRE = "genre_idGenre";
	
	public static final String MOVIE_LANGUAGE_TABLE = "movie_language";
	public static final String MOVIE_LANGUAGE_IDMOVIE = "movie_idmovie";
	public static final String MOVIE_LANGUAGE_LANGUAGE_CODE = "language_code";
	public static final String MOVIE_LANGUAGE_OVERVIEW = "overview";
	public static final String MOVIE_LANGUAGE_ALTERNATIVE_TITLE = "alternativetitle";
	public static final String MOVIE_LANGUAGE_TAGLINE = "tagline";
	
	public static final String MOVIE_PRODUCTION_TABLE = "movie_production";	
	public static final String MOVIE_PRODUCTION_IDMOVIE = "movie_idmovie";
	public static final String MOVIE_PRODUCTION_IDPRODUCTION = "production_idproduction";
	
	public static final String COUNTRY_PRODUCTION_TABLE = "country_production";
	public static final String COUNTRY_PRODUCTION_IDMOVIE = "movie_idmovie";
	public static final String COUNTRY_PRODUCTION_COUNTRY_CODE = "country_code";
	
	public static final String TRACING_TABLE = "Tracing";
	public static final String TRACING_IDMOVIE = "movie_idmovie";
	public static final String TRACING_ADDEDBY = "addedby";
	public static final String TRACING_ADDEDATE = "addedate";
	public static final String TRACING_TRACINGLANGUAGE = "tracinglanguage";
	public static final String TRACING_TRACED = "traced";
	public static final String TRACING_TRACEDDATE = "traceddate";
	public static final String TRACING_SOURCE = "source";
	public static final String TRACING_LINK = "link";
	
	public static final String TORRENT_TABLE = "Torrent";
	public static final String TORRENT_IDTORRENT = "idTorrent";
	public static final String TORRENT_TITLE = "title";
	public static final String TORRENT_WEBLINK = "weblink";
	public static final String TORRENT_GUID = "guid";
	public static final String TORRENT_DESCRIPTION = "description";
	public static final String TORRENT_COMMENTS = "comments";
	public static final String TORRENT_PUBDATE = "pubdate";
	public static final String TORRENT_INFOHASH = "infohash";
	public static final String TORRENT_FILEFORMAT = "fileFormat";
	public static final String TORRENT_RESOLUTION = "resolution";
	public static final String TORRENT_CONTENTLENGTH = "contentLength";
	public static final String TORRENT_MAGNET = "magnetURI";
	public static final String TORRENT_ADDEDDATE = "addedDate";
	public static final String TORRENT_ADDEDBY = "addedBy";
	public static final String TORRENT_CATEGORY = "Category_idCategory";
	public static final String TORRENT_CREATOR = "creator";
	public static final String TORRENT_MOVIE = "Movie_idMovie";
	public static final String TORRENT_SOURCE = "Source_idSource";
	public static final String TORRENT_LANGUAGE = "Language_code";
	
	public static final String SOURCE_TABLE = "Source";
	public static final String SOURCE_IDSOURCE = "idSource";
	public static final String SOURCE_NAME = "name";
	public static final String SOURCE_DOMAIN = "domain";
	public static final String SOURCE_ADDEDDATE = "addedDate";
	public static final String SOURCE_ADDEDBY = "addedBy";
	
	public static final String CATEGORY_TABLE = "Category";
	public static final String CATEGORY_IDCATEGORY = "idCategory";
	public static final String CATEGORY_NAME = "Name";
	
	public static final String CREATOR_TABLE = "Creator";
	public static final String CREATOR_IDCREATOR = "idCreator";
	public static final String CREATOR_NAME = "Name";
}
